alter table jms_dm.dm_mng_thd_flase_send_waybill_detail_mid_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_mng_thd_flase_send_waybill_detail_mid_dt;
CREATE EXTERNAL TABLE jms_dm.dm_mng_thd_flase_send_waybill_detail_mid_dt
(
    waybill_no                       string comment '运单号',
    input_time                       string comment '录入时间',
    send_station_network_code        string comment '当前站点code',
    send_station_network_name        string comment '当前站点code',
    send_station_network_type        string comment '当前站点类型',
    send_station_send_later_time     string comment '当前站点发件时间',
    send_station_arrival_early_time  string comment '当前站点到件时间',
    rn                               string comment '排序',
    no_send_arr_flag                 string comment '无到发时间',
    min_send_arr                     string comment '到发最小',
    min_scan_time                    string comment '操作最小',
    next_station_network_code        string comment '下一站点code',
    next_station_network_type        string comment '下一站点类型',
    next_station_send_later_time     string comment '下一站点发件时间',
    next_station_arrival_early_time  string comment '下一站点到件时间',
    first_scan_time                  string comment '首机构扫描时间',
    first_network_code               string comment '首机构网点',
    first_network_name               string comment '首机构网点',
    taking_early_scantime            string comment '揽收时间',
    taking_early_scansitecode        string comment '揽收网点',
    deliver_early_scantime           string comment '出仓时间',
    deliver_early_scansitecode       string comment '出仓网点',
    deliver_early_scansitename       string comment '出仓网点name',
    dispatch_network_code            string comment '派件网点',
    dispatch_network_name            string comment '派件网点',
    sign_time                        string comment '签收时间',
    first_center_network_code        string comment '第一中心code',
    first_center_arrival_early_time  string comment '第一中心到件时间',
    first_center_send_later_time     string comment '第一中心发件时间',
    second_center_network_code       string comment '第二中心code',
    second_center_arrival_early_time string comment '第二中心到件时间',
    second_center_send_later_time    string comment '第二中心发件时间',
    end_center_network_code          string comment '末端网点',
    first_center_provider_id         string comment '始发中心省份',
    first_center_provider_desc       string comment '始发中心省份desc',
    second_center_provider_id        string comment '第二中心省份',
    second_center_provider_desc      string comment '第二中心省份desc',
    is_same_prov_flag                string comment '1第一第二中心是同一省份',
    first_network_provider_id        string comment '始发机构省份id',
    first_network_provider_desc      string comment '始发机构省份desc',
    first_network_city_id            string comment '始发机构城市id',
    first_network_city_desc          string comment '始发机构城市desc',
    first_network_agent_code         string comment '始发机构代理区code',
    first_network_agent_name         string comment '始发机构代理区name',
    dispatch_network_provider_id     string comment '派件机构省份id',
    dispatch_network_provider_desc   string comment '派件机构省份desc',
    dispatch_network_city_id         string comment '派件机构城市id',
    dispatch_network_city_desc       string comment '派件机构城市desc',
    dispatch_network_agent_code      string comment '派件机构代理区code',
    dispatch_network_agent_name      string comment '派件机构代理区name',
    deliver_provider_id              string comment '出仓网点省份id',
    deliver_provider_desc            string comment '出仓网点省份desc',
    deliver_city_id                  string comment '出仓网点城市id',
    deliver_city_desc                string comment '出仓网点城市desc',
    remote_timeout                   string comment '偏远地区时长',
    extremely_remote_timeout         string comment '级偏远地区时长',
    timeout                          string comment '地区时长',
    date_time                        string comment '日期'
) COMMENT '春节不打烊-桃花岛虚假发货明细'
    PARTITIONED BY (
        dt string COMMENT '录入时间')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_mng_thd_flase_send_waybill_detail_mid_dt'
;